ʹùӵservletԴļ
ShareInquire.java:
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class ShareInquire extends HttpServlet
{  Connection con=null; //ӡ
  public void init(ServletConfig config) throws ServletException
    {super.init(config);
      //JDBC-ODBCŽ
       try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          }
       catch(ClassNotFoundException e){}
    }
   //ͨPostֲѯ¼
  public  void doPost(HttpServletRequest request,HttpServletResponse response) 
                        throws ServletException,IOException
  { PrintWriter out=response.getWriter();
    response.setContentType("text/html;charset=GB2312");//ӦMIME͡
    out.println("<HTML>"); 
    out.println("<BODY>");
    Statement sql=null; 
    ResultSet rs=null; 
    if(con==null) 
    { try
       {   //һûcon
           con=DriverManager.getConnection("jdbc:odbc:sun","sa","");
           sql=con.createStatement();
           String condition="SELECT * FROM students";
           rs=sql.executeQuery(condition);
        out.print("<Table Border>");
            out.print("<TR>");
            out.print("<TH width=100>"+"Number");
            out.print("<TH width=100>"+"Name");
            out.print("<TH width=50>"+"Math");
            out.print("<TH width=50>"+"English");
            out.print("<TH width=50>"+"Phsics");
            out.print("</TR>");
       while(rs.next())
           { out.print("<TR>");
             out.print("<TD >"+rs.getString(1)+"</TD>"); 
             out.print("<TD >"+rs.getString(2)+"</TD>");
             out.print("<TD >"+rs.getInt("ѧɼ")+"</TD>"); 
             out.print("<TD >"+rs.getInt("Ӣɼ")+"</TD>");
             out.print("<TD >"+rs.getInt("ɼ")+"</TD>");   
             out.print("</TR>") ;          
            }
         out.print("</Table>");
       }
     catch(SQLException e)
          {
          }
    }
   //ͻͨͬʹӣ
   else
    { synchronized(con)
       {try{ sql=con.createStatement();
             String condition="SELECT * FROM students";
             rs=sql.executeQuery(condition);
             out.print("<Table Border>");
             out.print("<TR>");
             out.print("<TH width=100>"+"Number");
             out.print("<TH width=100>"+"Name");
             out.print("<TH width=50>"+"Math");
             out.print("<TH width=50>"+"English");
             out.print("<TH width=50>"+"Phsics");
             out.print("</TR>");
             while(rs.next())
              { out.print("<TR>");
                out.print("<TD >"+rs.getString(1)+"</TD>"); 
                out.print("<TD >"+rs.getString(2)+"</TD>");
                out.print("<TD >"+rs.getInt("ѧɼ")+"</TD>"); 
                out.print("<TD >"+rs.getInt("Ӣɼ")+"</TD>");
                out.print("<TD >"+rs.getInt("ɼ")+"</TD>");   
                out.print("</TR>") ;          
              }
            out.print("</Table>");
          }
        catch(SQLException e)
          {
          }
       }
    }
   out.println("</BODY>");
   out.println("</HTML>");
 }
  public void doGet(HttpServletRequest request,HttpServletResponse response) 
                        throws ServletException,IOException
 {  doPost(request,response);
 }
}
